Hệ thống quản lý bệnh viện bằng C# với mã nguồn

• hospitalDataSet1.Designer.cs
• project /

1 //------------------------------------------------------------------------------
2 // <auto-generated>
3 // This code was generated by a tool.
4 // Runtime Version:4.0.30319.42000
5 //
6 // Changes to this file may cause incorrect behavior and will be lost if
7 // the code is regenerated.
8 // </auto-generated>
9 //------------------------------------------------------------------------------
10
11 #pragma warning disable 1591
12
13 namespace HospitalManagementSystemCSharp {
14     
15     
16     /// <summary>
17     ///Represents a strongly typed in-memory cache of data.
18     ///</summary>
19     [global::System.Serializable()]
20     [global::System.ComponentModel.DesignerCategoryAttribute("code")]
21     [global::System.ComponentModel.ToolboxItem(true)]
22     [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
23     [global::System.Xml.Serialization.XmlRootAttribute("hospitalDataSet1")]
24     [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
25     public partial class hospitalDataSet1 : global::System.Data.DataSet {
26         
27         private patientDataTable tablepatient;
28         
29         private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
30         
31         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
32         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
33         public hospitalDataSet1() {
34             this.BeginInit();
35             this.InitClass();
36             global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
37             base.Tables.CollectionChanged += schemaChangedHandler;
38             base.Relations.CollectionChanged += schemaChangedHandler;
39             this.EndInit();
40         }
41         
42         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
43         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
44         protected hospitalDataSet1(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
45                 base(info, context, false) {
46             if ((this.IsBinarySerialized(info, context) == true)) {
47                 this.InitVars(false);
48                 global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
49                 this.Tables.CollectionChanged += schemaChangedHandler1;
50                 this.Relations.CollectionChanged += schemaChangedHandler1;
51                 return;
52             }
53             string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
54             if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
55                 global::System.Data.DataSet ds = new global::System.Data.DataSet();
56                 ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
57                 if ((ds.Tables["patient"] != null)) {
58                     base.Tables.Add(new patientDataTable(ds.Tables["patient"]));
59                 }
60                 this.DataSetName = ds.DataSetName;
61                 this.Prefix = ds.Prefix;
62                 this.Namespace = ds.Namespace;
63                 this.Locale = ds.Locale;
64                 this.CaseSensitive = ds.CaseSensitive;
65                 this.EnforceConstraints = ds.EnforceConstraints;
66                 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
67                 this.InitVars();
68             }
69             else {
70                 this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
71             }
72             this.GetSerializationData(info, context);
73             global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
74             base.Tables.CollectionChanged += schemaChangedHandler;
75             this.Relations.CollectionChanged += schemaChangedHandler;
76         }
77         
78         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
79         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
80         [global::System.ComponentModel.Browsable(false)]
81         [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
82         public patientDataTable patient {
83             get {
84                 return this.tablepatient;
85             }
86         }
87         
88         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
89         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
90         [global::System.ComponentModel.BrowsableAttribute(true)]
91         [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
92         public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
93             get {
94                 return this._schemaSerializationMode;
95             }
96             set {
97                 this._schemaSerializationMode = value;
98             }
99         }
100         
101         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
102         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
103         [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
104         public new global::System.Data.DataTableCollection Tables {
105             get {
106                 return base.Tables;
107             }
108         }
109         
110         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
111         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
112         [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
113         public new global::System.Data.DataRelationCollection Relations {
114             get {
115                 return base.Relations;
116             }
117         }
118         
119         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
120         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
121         protected override void InitializeDerivedDataSet() {
122             this.BeginInit();
123             this.InitClass();
124             this.EndInit();
125         }
126         
127         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
128         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
129         public override global::System.Data.DataSet Clone() {
130             hospitalDataSet1 cln = ((hospitalDataSet1)(base.Clone()));
131             cln.InitVars();
132             cln.SchemaSerializationMode = this.SchemaSerializationMode;
133             return cln;
134         }
135         
136         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
137         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
138         protected override bool ShouldSerializeTables() {
139             return false;
140         }
141         
142         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
143         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
144         protected override bool ShouldSerializeRelations() {
145             return false;
146         }
147         
148         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
149         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
150         protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
151             if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
152                 this.Reset();
153                 global::System.Data.DataSet ds = new global::System.Data.DataSet();
154                 ds.ReadXml(reader);
155                 if ((ds.Tables["patient"] != null)) {
156                     base.Tables.Add(new patientDataTable(ds.Tables["patient"]));
157                 }
158                 this.DataSetName = ds.DataSetName;
159                 this.Prefix = ds.Prefix;
160                 this.Namespace = ds.Namespace;
161                 this.Locale = ds.Locale;
162                 this.CaseSensitive = ds.CaseSensitive;
163                 this.EnforceConstraints = ds.EnforceConstraints;
164                 this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
165                 this.InitVars();
166             }
167             else {
168                 this.ReadXml(reader);
169                 this.InitVars();
170             }
171         }
172         
173         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
174         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
175         protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
176             global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
177             this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
178             stream.Position = 0;
179             return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
180         }
181         
182         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
183         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
184         internal void InitVars() {
185             this.InitVars(true);
186         }
187         
188         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
189         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
190         internal void InitVars(bool initTable) {
191             this.tablepatient = ((patientDataTable)(base.Tables["patient"]));
192             if ((initTable == true)) {
193                 if ((this.tablepatient != null)) {
194                     this.tablepatient.InitVars();
195                 }
196             }
197         }
198         
199         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
200         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
201         private void InitClass() {
202             this.DataSetName = "hospitalDataSet1";
203             this.Prefix = "";
204             this.Namespace = "http://tempuri.org/hospitalDataSet1.xsd";
205             this.EnforceConstraints = true;
206             this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
207             this.tablepatient = new patientDataTable();
208             base.Tables.Add(this.tablepatient);
209         }
210         
211         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
212         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
213         private bool ShouldSerializepatient() {
214             return false;
215         }
216         
217         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
218         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
219         private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
220             if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
221                 this.InitVars();
222             }
223         }
224         
225         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
226         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
227         public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
228             hospitalDataSet1 ds = new hospitalDataSet1();
229             global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
230             global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
231             global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
232             any.Namespace = ds.Namespace;
233             sequence.Items.Add(any);
234             type.Particle = sequence;
235             global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
236             if (xs.Contains(dsSchema.TargetNamespace)) {
237                 global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
238                 global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
239                 try {
240                     global::System.Xml.Schema.XmlSchema schema = null;
241                     dsSchema.Write(s1);
242                     for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
243                         schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
244                         s2.SetLength(0);
245                         schema.Write(s2);
246                         if ((s1.Length == s2.Length)) {
247                             s1.Position = 0;
248                             s2.Position = 0;
249                             for (; ((s1.Position != s1.Length)
250                                         && (s1.ReadByte() == s2.ReadByte())); ) {
251                                 ;
252                             }
253                             if ((s1.Position == s1.Length)) {
254                                 return type;
255                             }
256                         }
257                     }
258                 }
259                 finally {
260                     if ((s1 != null)) {
261                         s1.Close();
262                     }
263                     if ((s2 != null)) {
264                         s2.Close();
265                     }
266                 }
267             }
268             xs.Add(dsSchema);
269             return type;
270         }
271         
272         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
273         public delegate void patientRowChangeEventHandler(object sender, patientRowChangeEvent e);
274         
275         /// <summary>
276         ///Represents the strongly named DataTable class.
277         ///</summary>
278         [global::System.Serializable()]
279         [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
280         public partial class patientDataTable : global::System.Data.TypedTableBase<patientRow> {
281             
282             private global::System.Data.DataColumn columnId;
283             
284             private global::System.Data.DataColumn columnname;
285             
286             private global::System.Data.DataColumn columngen;
287             
288             private global::System.Data.DataColumn columnage;
289             
290             private global::System.Data.DataColumn columndate;
291             
292             private global::System.Data.DataColumn columncont;
293             
294             private global::System.Data.DataColumn columnaddr;
295             
296             private global::System.Data.DataColumn columndisease;
297             
298             private global::System.Data.DataColumn columnstatus;
299             
300             private global::System.Data.DataColumn columnr_type;
301             
302             private global::System.Data.DataColumn columnbuilding;
303             
304             private global::System.Data.DataColumn columnr_no;
305             
306             private global::System.Data.DataColumn columnprice;
307             
308             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
309             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
310             public patientDataTable() {
311                 this.TableName = "patient";
312                 this.BeginInit();
313                 this.InitClass();
314                 this.EndInit();
315             }
316             
317             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
318             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
319             internal patientDataTable(global::System.Data.DataTable table) {
320                 this.TableName = table.TableName;
321                 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
322                     this.CaseSensitive = table.CaseSensitive;
323                 }
324                 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
325                     this.Locale = table.Locale;
326                 }
327                 if ((table.Namespace != table.DataSet.Namespace)) {
328                     this.Namespace = table.Namespace;
329                 }
330                 this.Prefix = table.Prefix;
331                 this.MinimumCapacity = table.MinimumCapacity;
332             }
333             
334             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
335             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
336             protected patientDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
337                     base(info, context) {
338                 this.InitVars();
339             }
340             
341             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
342             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
343             public global::System.Data.DataColumn IdColumn {
344                 get {
345                     return this.columnId;
346                 }
347             }
348             
349             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
350             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
351             public global::System.Data.DataColumn nameColumn {
352                 get {
353                     return this.columnname;
354                 }
355             }
356             
357             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
358             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
359             public global::System.Data.DataColumn genColumn {
360                 get {
361                     return this.columngen;
362                 }
363             }
364             
365             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
366             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
367             public global::System.Data.DataColumn ageColumn {
368                 get {
369                     return this.columnage;
370                 }
371             }
372             
373             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
374             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
375             public global::System.Data.DataColumn dateColumn {
376                 get {
377                     return this.columndate;
378                 }
379             }
380             
381             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
382             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
383             public global::System.Data.DataColumn contColumn {
384                 get {
385                     return this.columncont;
386                 }
387             }
388             
389             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
390             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
391             public global::System.Data.DataColumn addrColumn {
392                 get {
393                     return this.columnaddr;
394                 }
395             }
396             
397             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
398             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
399             public global::System.Data.DataColumn diseaseColumn {
400                 get {
401                     return this.columndisease;
402                 }
403             }
404             
405             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
406             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
407             public global::System.Data.DataColumn statusColumn {
408                 get {
409                     return this.columnstatus;
410                 }
411             }
412             
413             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
414             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
415             public global::System.Data.DataColumn r_typeColumn {
416                 get {
417                     return this.columnr_type;
418                 }
419             }
420             
421             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
422             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
423             public global::System.Data.DataColumn buildingColumn {
424                 get {
425                     return this.columnbuilding;
426                 }
427             }
428             
429             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
430             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
431             public global::System.Data.DataColumn r_noColumn {
432                 get {
433                     return this.columnr_no;
434                 }
435             }
436             
437             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
438             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
439             public global::System.Data.DataColumn priceColumn {
440                 get {
441                     return this.columnprice;
442                 }
443             }
444             
445             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
446             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
447             [global::System.ComponentModel.Browsable(false)]
448             public int Count {
449                 get {
450                     return this.Rows.Count;
451                 }
452             }
453             
454             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
455             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
456             public patientRow this[int index] {
457                 get {
458                     return ((patientRow)(this.Rows[index]));
459                 }
460             }
461             
462             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
463             public event patientRowChangeEventHandler patientRowChanging;
464             
465             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
466             public event patientRowChangeEventHandler patientRowChanged;
467             
468             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
469             public event patientRowChangeEventHandler patientRowDeleting;
470             
471             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
472             public event patientRowChangeEventHandler patientRowDeleted;
473             
474             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
475             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
476             public void AddpatientRow(patientRow row) {
477                 this.Rows.Add(row);
478             }
479             
480             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
481             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
482             public patientRow AddpatientRow(int Id, string name, string gen, string age, string date, string cont, string addr, string disease, string status, string r_type, string building, string r_no, string price) {
483                 patientRow rowpatientRow = ((patientRow)(this.NewRow()));
484                 object[] columnValuesArray = new object[] {
485                         Id,
486                         name,
487                         gen,
488                         age,
489                         date,
490                         cont,
491                         addr,
492                         disease,
493                         status,
494                         r_type,
495                         building,
496                         r_no,
497                         price};
498                 rowpatientRow.ItemArray = columnValuesArray;
499                 this.Rows.Add(rowpatientRow);
500                 return rowpatientRow;
501             }
502             
503             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
504             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
505             public patientRow FindById(int Id) {
506                 return ((patientRow)(this.Rows.Find(new object[] {
507                             Id})));
508             }
509             
510             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
511             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
512             public override global::System.Data.DataTable Clone() {
513                 patientDataTable cln = ((patientDataTable)(base.Clone()));
514                 cln.InitVars();
515                 return cln;
516             }
517             
518             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
519             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
520             protected override global::System.Data.DataTable CreateInstance() {
521                 return new patientDataTable();
522             }
523             
524             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
525             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
526             internal void InitVars() {
527                 this.columnId = base.Columns["Id"];
528                 this.columnname = base.Columns["name"];
529                 this.columngen = base.Columns["gen"];
530                 this.columnage = base.Columns["age"];
531                 this.columndate = base.Columns["date"];
532                 this.columncont = base.Columns["cont"];
533                 this.columnaddr = base.Columns["addr"];
534                 this.columndisease = base.Columns["disease"];
535                 this.columnstatus = base.Columns["status"];
536                 this.columnr_type = base.Columns["r_type"];
537                 this.columnbuilding = base.Columns["building"];
538                 this.columnr_no = base.Columns["r_no"];
539                 this.columnprice = base.Columns["price"];
540             }
541             
542             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
543             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
544             private void InitClass() {
545                 this.columnId = new global::System.Data.DataColumn("Id", typeof(int), null, global::System.Data.MappingType.Element);
546                 base.Columns.Add(this.columnId);
547                 this.columnname = new global::System.Data.DataColumn("name", typeof(string), null, global::System.Data.MappingType.Element);
548                 base.Columns.Add(this.columnname);
549                 this.columngen = new global::System.Data.DataColumn("gen", typeof(string), null, global::System.Data.MappingType.Element);
550                 base.Columns.Add(this.columngen);
551                 this.columnage = new global::System.Data.DataColumn("age", typeof(string), null, global::System.Data.MappingType.Element);
552                 base.Columns.Add(this.columnage);
553                 this.columndate = new global::System.Data.DataColumn("date", typeof(string), null, global::System.Data.MappingType.Element);
554                 base.Columns.Add(this.columndate);
555                 this.columncont = new global::System.Data.DataColumn("cont", typeof(string), null, global::System.Data.MappingType.Element);
556                 base.Columns.Add(this.columncont);
557                 this.columnaddr = new global::System.Data.DataColumn("addr", typeof(string), null, global::System.Data.MappingType.Element);
558                 base.Columns.Add(this.columnaddr);
559                 this.columndisease = new global::System.Data.DataColumn("disease", typeof(string), null, global::System.Data.MappingType.Element);
560                 base.Columns.Add(this.columndisease);
561                 this.columnstatus = new global::System.Data.DataColumn("status", typeof(string), null, global::System.Data.MappingType.Element);
562                 base.Columns.Add(this.columnstatus);
563                 this.columnr_type = new global::System.Data.DataColumn("r_type", typeof(string), null, global::System.Data.MappingType.Element);
564                 base.Columns.Add(this.columnr_type);
565                 this.columnbuilding = new global::System.Data.DataColumn("building", typeof(string), null, global::System.Data.MappingType.Element);
566                 base.Columns.Add(this.columnbuilding);
567                 this.columnr_no = new global::System.Data.DataColumn("r_no", typeof(string), null, global::System.Data.MappingType.Element);
568                 base.Columns.Add(this.columnr_no);
569                 this.columnprice = new global::System.Data.DataColumn("price", typeof(string), null, global::System.Data.MappingType.Element);
570                 base.Columns.Add(this.columnprice);
571                 this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
572                                 this.columnId}, true));
573                 this.columnId.AllowDBNull = false;
574                 this.columnId.Unique = true;
575                 this.columnname.MaxLength = 50;
576                 this.columngen.MaxLength = 50;
577                 this.columnage.MaxLength = 50;
578                 this.columndate.MaxLength = 50;
579                 this.columncont.MaxLength = 50;
580                 this.columnaddr.MaxLength = 50;
581                 this.columndisease.MaxLength = 50;
582                 this.columnstatus.MaxLength = 50;
583                 this.columnr_type.MaxLength = 50;
584                 this.columnbuilding.MaxLength = 50;
585                 this.columnr_no.MaxLength = 50;
586                 this.columnprice.MaxLength = 50;
587             }
588             
589             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
590             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
591             public patientRow NewpatientRow() {
592                 return ((patientRow)(this.NewRow()));
593             }
594             
595             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
596             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
597             protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
598                 return new patientRow(builder);
599             }
600             
601             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
602             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
603             protected override global::System.Type GetRowType() {
604                 return typeof(patientRow);
605             }
606             
607             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
608             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
609             protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
610                 base.OnRowChanged(e);
611                 if ((this.patientRowChanged != null)) {
612                     this.patientRowChanged(this, new patientRowChangeEvent(((patientRow)(e.Row)), e.Action));
613                 }
614             }
615             
616             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
617             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
618             protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
619                 base.OnRowChanging(e);
620                 if ((this.patientRowChanging != null)) {
621                     this.patientRowChanging(this, new patientRowChangeEvent(((patientRow)(e.Row)), e.Action));
622                 }
623             }
624             
625             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
626             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
627             protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
628                 base.OnRowDeleted(e);
629                 if ((this.patientRowDeleted != null)) {
630                     this.patientRowDeleted(this, new patientRowChangeEvent(((patientRow)(e.Row)), e.Action));
631                 }
632             }
633             
634             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
635             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
636             protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
637                 base.OnRowDeleting(e);
638                 if ((this.patientRowDeleting != null)) {
639                     this.patientRowDeleting(this, new patientRowChangeEvent(((patientRow)(e.Row)), e.Action));
640                 }
641             }
642             
643             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
644             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
645             public void RemovepatientRow(patientRow row) {
646                 this.Rows.Remove(row);
647             }
648             
649             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
650             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
651             public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
652                 global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
653                 global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
654                 hospitalDataSet1 ds = new hospitalDataSet1();
655                 global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
656                 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
657                 any1.MinOccurs = new decimal(0);
658                 any1.MaxOccurs = decimal.MaxValue;
659                 any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
660                 sequence.Items.Add(any1);
661                 global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
662                 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
663                 any2.MinOccurs = new decimal(1);
664                 any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
665                 sequence.Items.Add(any2);
666                 global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
667                 attribute1.Name = "namespace";
668                 attribute1.FixedValue = ds.Namespace;
669                 type.Attributes.Add(attribute1);
670                 global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
671                 attribute2.Name = "tableTypeName";
672                 attribute2.FixedValue = "patientDataTable";
673                 type.Attributes.Add(attribute2);
674                 type.Particle = sequence;
675                 global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
676                 if (xs.Contains(dsSchema.TargetNamespace)) {
677                     global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
678                     global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
679                     try {
680                         global::System.Xml.Schema.XmlSchema schema = null;
681                         dsSchema.Write(s1);
682                         for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
683                             schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
684                             s2.SetLength(0);
685                             schema.Write(s2);
686                             if ((s1.Length == s2.Length)) {
687                                 s1.Position = 0;
688                                 s2.Position = 0;
689                                 for (; ((s1.Position != s1.Length)
690                                             && (s1.ReadByte() == s2.ReadByte())); ) {
691                                     ;
692                                 }
693                                 if ((s1.Position == s1.Length)) {
694                                     return type;
695                                 }
696                             }
697                         }
698                     }
699                     finally {
700                         if ((s1 != null)) {
701                             s1.Close();
702                         }
703                         if ((s2 != null)) {
704                             s2.Close();
705                         }
706                     }
707                 }
708                 xs.Add(dsSchema);
709                 return type;
710             }
711         }
712         
713         /// <summary>
714         ///Represents strongly named DataRow class.
715         ///</summary>
716         public partial class patientRow : global::System.Data.DataRow {
717             
718             private patientDataTable tablepatient;
719             
720             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
721             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
722             internal patientRow(global::System.Data.DataRowBuilder rb) :
723                     base(rb) {
724                 this.tablepatient = ((patientDataTable)(this.Table));
725             }
726             
727             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
728             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
729             public int Id {
730                 get {
731                     return ((int)(this[this.tablepatient.IdColumn]));
732                 }
733                 set {
734                     this[this.tablepatient.IdColumn] = value;
735                 }
736             }
737             
738             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
739             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
740             public string name {
741                 get {
742                     try {
743                         return ((string)(this[this.tablepatient.nameColumn]));
744                     }
745                     catch (global::System.InvalidCastException e) {
746                         throw new global::System.Data.StrongTypingException("The value for column \'name\' in table \'patient\' is DBNull.", e);
747                     }
748                 }
749                 set {
750                     this[this.tablepatient.nameColumn] = value;
751                 }
752             }
753             
754             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
755             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
756             public string gen {
757                 get {
758                     try {
759                         return ((string)(this[this.tablepatient.genColumn]));
760                     }
761                     catch (global::System.InvalidCastException e) {
762                         throw new global::System.Data.StrongTypingException("The value for column \'gen\' in table \'patient\' is DBNull.", e);
763                     }
764                 }
765                 set {
766                     this[this.tablepatient.genColumn] = value;
767                 }
768             }
769             
770             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
771             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
772             public string age {
773                 get {
774                     try {
775                         return ((string)(this[this.tablepatient.ageColumn]));
776                     }
777                     catch (global::System.InvalidCastException e) {
778                         throw new global::System.Data.StrongTypingException("The value for column \'age\' in table \'patient\' is DBNull.", e);
779                     }
780                 }
781                 set {
782                     this[this.tablepatient.ageColumn] = value;
783                 }
784             }
785             
786             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
787             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
788             public string date {
789                 get {
790                     try {
791                         return ((string)(this[this.tablepatient.dateColumn]));
792                     }
793                     catch (global::System.InvalidCastException e) {
794                         throw new global::System.Data.StrongTypingException("The value for column \'date\' in table \'patient\' is DBNull.", e);
795                     }
796                 }
797                 set {
798                     this[this.tablepatient.dateColumn] = value;
799                 }
800             }
801             
802             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
803             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
804             public string cont {
805                 get {
806                     try {
807                         return ((string)(this[this.tablepatient.contColumn]));
808                     }
809                     catch (global::System.InvalidCastException e) {
810                         throw new global::System.Data.StrongTypingException("The value for column \'cont\' in table \'patient\' is DBNull.", e);
811                     }
812                 }
813                 set {
814                     this[this.tablepatient.contColumn] = value;
815                 }
816             }
817             
818             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
819             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
820             public string addr {
821                 get {
822                     try {
823                         return ((string)(this[this.tablepatient.addrColumn]));
824                     }
825                     catch (global::System.InvalidCastException e) {
826                         throw new global::System.Data.StrongTypingException("The value for column \'addr\' in table \'patient\' is DBNull.", e);
827                     }
828                 }
829                 set {
830                     this[this.tablepatient.addrColumn] = value;
831                 }
832             }
833             
834             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
835             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
836             public string disease {
837                 get {
838                     try {
839                         return ((string)(this[this.tablepatient.diseaseColumn]));
840                     }
841                     catch (global::System.InvalidCastException e) {
842                         throw new global::System.Data.StrongTypingException("The value for column \'disease\' in table \'patient\' is DBNull.", e);
843                     }
844                 }
845                 set {
846                     this[this.tablepatient.diseaseColumn] = value;
847                 }
848             }
849             
850             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
851             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
852             public string status {
853                 get {
854                     try {
855                         return ((string)(this[this.tablepatient.statusColumn]));
856                     }
857                     catch (global::System.InvalidCastException e) {
858                         throw new global::System.Data.StrongTypingException("The value for column \'status\' in table \'patient\' is DBNull.", e);
859                     }
860                 }
861                 set {
862                     this[this.tablepatient.statusColumn] = value;
863                 }
864             }
865             
866             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
867             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
868             public string r_type {
869                 get {
870                     try {
871                         return ((string)(this[this.tablepatient.r_typeColumn]));
872                     }
873                     catch (global::System.InvalidCastException e) {
874                         throw new global::System.Data.StrongTypingException("The value for column \'r_type\' in table \'patient\' is DBNull.", e);
875                     }
876                 }
877                 set {
878                     this[this.tablepatient.r_typeColumn] = value;
879                 }
880             }
881             
882             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
883             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
884             public string building {
885                 get {
886                     try {
887                         return ((string)(this[this.tablepatient.buildingColumn]));
888                     }
889                     catch (global::System.InvalidCastException e) {
890                         throw new global::System.Data.StrongTypingException("The value for column \'building\' in table \'patient\' is DBNull.", e);
891                     }
892                 }
893                 set {
894                     this[this.tablepatient.buildingColumn] = value;
895                 }
896             }
897             
898             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
899             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
900             public string r_no {
901                 get {
902                     try {
903                         return ((string)(this[this.tablepatient.r_noColumn]));
904                     }
905                     catch (global::System.InvalidCastException e) {
906                         throw new global::System.Data.StrongTypingException("The value for column \'r_no\' in table \'patient\' is DBNull.", e);
907                     }
908                 }
909                 set {
910                     this[this.tablepatient.r_noColumn] = value;
911                 }
912             }
913             
914             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
915             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
916             public string price {
917                 get {
918                     try {
919                         return ((string)(this[this.tablepatient.priceColumn]));
920                     }
921                     catch (global::System.InvalidCastException e) {
922                         throw new global::System.Data.StrongTypingException("The value for column \'price\' in table \'patient\' is DBNull.", e);
923                     }
924                 }
925                 set {
926                     this[this.tablepatient.priceColumn] = value;
927                 }
928             }
929             
930             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
931             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
932             public bool IsnameNull() {
933                 return this.IsNull(this.tablepatient.nameColumn);
934             }
935             
936             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
937             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
938             public void SetnameNull() {
939                 this[this.tablepatient.nameColumn] = global::System.Convert.DBNull;
940             }
941             
942             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
943             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
944             public bool IsgenNull() {
945                 return this.IsNull(this.tablepatient.genColumn);
946             }
947             
948             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
949             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
950             public void SetgenNull() {
951                 this[this.tablepatient.genColumn] = global::System.Convert.DBNull;
952             }
953             
954             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
955             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
956             public bool IsageNull() {
957                 return this.IsNull(this.tablepatient.ageColumn);
958             }
959             
960             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
961             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
962             public void SetageNull() {
963                 this[this.tablepatient.ageColumn] = global::System.Convert.DBNull;
964             }
965             
966             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
967             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
968             public bool IsdateNull() {
969                 return this.IsNull(this.tablepatient.dateColumn);
970             }
971             
972             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
973             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
974             public void SetdateNull() {
975                 this[this.tablepatient.dateColumn] = global::System.Convert.DBNull;
976             }
977             
978             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
979             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
980             public bool IscontNull() {
981                 return this.IsNull(this.tablepatient.contColumn);
982             }
983             
984             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
985             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
986             public void SetcontNull() {
987                 this[this.tablepatient.contColumn] = global::System.Convert.DBNull;
988             }
989             
990             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
991             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
992             public bool IsaddrNull() {
993                 return this.IsNull(this.tablepatient.addrColumn);
994             }
995             
996             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
997             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
998             public void SetaddrNull() {
999                 this[this.tablepatient.addrColumn] = global::System.Convert.DBNull;
1000             }
1001             
1002             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1003             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1004             public bool IsdiseaseNull() {
1005                 return this.IsNull(this.tablepatient.diseaseColumn);
1006             }
1007             
1008             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1009             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1010             public void SetdiseaseNull() {
1011                 this[this.tablepatient.diseaseColumn] = global::System.Convert.DBNull;
1012             }
1013             
1014             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1015             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1016             public bool IsstatusNull() {
1017                 return this.IsNull(this.tablepatient.statusColumn);
1018             }
1019             
1020             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1021             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1022             public void SetstatusNull() {
1023                 this[this.tablepatient.statusColumn] = global::System.Convert.DBNull;
1024             }
1025             
1026             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1027             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1028             public bool Isr_typeNull() {
1029                 return this.IsNull(this.tablepatient.r_typeColumn);
1030             }
1031             
1032             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1033             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1034             public void Setr_typeNull() {
1035                 this[this.tablepatient.r_typeColumn] = global::System.Convert.DBNull;
1036             }
1037             
1038             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1039             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1040             public bool IsbuildingNull() {
1041                 return this.IsNull(this.tablepatient.buildingColumn);
1042             }
1043             
1044             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1045             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1046             public void SetbuildingNull() {
1047                 this[this.tablepatient.buildingColumn] = global::System.Convert.DBNull;
1048             }
1049             
1050             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1051             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1052             public bool Isr_noNull() {
1053                 return this.IsNull(this.tablepatient.r_noColumn);
1054             }
1055             
1056             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1057             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1058             public void Setr_noNull() {
1059                 this[this.tablepatient.r_noColumn] = global::System.Convert.DBNull;
1060             }
1061             
1062             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1063             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1064             public bool IspriceNull() {
1065                 return this.IsNull(this.tablepatient.priceColumn);
1066             }
1067             
1068             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1069             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1070             public void SetpriceNull() {
1071                 this[this.tablepatient.priceColumn] = global::System.Convert.DBNull;
1072             }
1073         }
1074         
1075         /// <summary>
1076         ///Row event argument class
1077         ///</summary>
1078         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1079         public class patientRowChangeEvent : global::System.EventArgs {
1080             
1081             private patientRow eventRow;
1082             
1083             private global::System.Data.DataRowAction eventAction;
1084             
1085             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1086             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1087             public patientRowChangeEvent(patientRow row, global::System.Data.DataRowAction action) {
1088                 this.eventRow = row;
1089                 this.eventAction = action;
1090             }
1091             
1092             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1093             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1094             public patientRow Row {
1095                 get {
1096                     return this.eventRow;
1097                 }
1098             }
1099             
1100             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1101             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1102             public global::System.Data.DataRowAction Action {
1103                 get {
1104                     return this.eventAction;
1105                 }
1106             }
1107         }
1108     }
1109 }
1110 namespace HospitalManagementSystemCSharp.hospitalDataSet1TableAdapters {
1111     
1112     
1113     /// <summary>
1114     ///Represents the connection and commands used to retrieve and save data.
1115     ///</summary>
1116     [global::System.ComponentModel.DesignerCategoryAttribute("code")]
1117     [global::System.ComponentModel.ToolboxItem(true)]
1118     [global::System.ComponentModel.DataObjectAttribute(true)]
1119     [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
1120         ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
1121     [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1122     public partial class patientTableAdapter : global::System.ComponentModel.Component {
1123         
1124         private global::System.Data.SqlClient.SqlDataAdapter _adapter;
1125         
1126         private global::System.Data.SqlClient.SqlConnection _connection;
1127         
1128         private global::System.Data.SqlClient.SqlTransaction _transaction;
1129         
1130         private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
1131         
1132         private bool _clearBeforeFill;
1133         
1134         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1135         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1136         public patientTableAdapter() {
1137             this.ClearBeforeFill = true;
1138         }
1139         
1140         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1141         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1142         protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
1143             get {
1144                 if ((this._adapter == null)) {
1145                     this.InitAdapter();
1146                 }
1147                 return this._adapter;
1148             }
1149         }
1150         
1151         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1152         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1153         internal global::System.Data.SqlClient.SqlConnection Connection {
1154             get {
1155                 if ((this._connection == null)) {
1156                     this.InitConnection();
1157                 }
1158                 return this._connection;
1159             }
1160             set {
1161                 this._connection = value;
1162                 if ((this.Adapter.InsertCommand != null)) {
1163                     this.Adapter.InsertCommand.Connection = value;
1164                 }
1165                 if ((this.Adapter.DeleteCommand != null)) {
1166                     this.Adapter.DeleteCommand.Connection = value;
1167                 }
1168                 if ((this.Adapter.UpdateCommand != null)) {
1169                     this.Adapter.UpdateCommand.Connection = value;
1170                 }
1171                 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
1172                     if ((this.CommandCollection[i] != null)) {
1173                         ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
1174                     }
1175                 }
1176             }
1177         }
1178         
1179         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1180         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1181         internal global::System.Data.SqlClient.SqlTransaction Transaction {
1182             get {
1183                 return this._transaction;
1184             }
1185             set {
1186                 this._transaction = value;
1187                 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
1188                     this.CommandCollection[i].Transaction = this._transaction;
1189                 }
1190                 if (((this.Adapter != null)
1191                             && (this.Adapter.DeleteCommand != null))) {
1192                     this.Adapter.DeleteCommand.Transaction = this._transaction;
1193                 }
1194                 if (((this.Adapter != null)
1195                             && (this.Adapter.InsertCommand != null))) {
1196                     this.Adapter.InsertCommand.Transaction = this._transaction;
1197                 }
1198                 if (((this.Adapter != null)
1199                             && (this.Adapter.UpdateCommand != null))) {
1200                     this.Adapter.UpdateCommand.Transaction = this._transaction;
1201                 }
1202             }
1203         }
1204         
1205         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1206         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1207         protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
1208             get {
1209                 if ((this._commandCollection == null)) {
1210                     this.InitCommandCollection();
1211                 }
1212                 return this._commandCollection;
1213             }
1214         }
1215         
1216         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1217         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1218         public bool ClearBeforeFill {
1219             get {
1220                 return this._clearBeforeFill;
1221             }
1222             set {
1223                 this._clearBeforeFill = value;
1224             }
1225         }
1226         
1227         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1228         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1229         private void InitAdapter() {
1230             this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
1231             global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
1232             tableMapping.SourceTable = "Table";
1233             tableMapping.DataSetTable = "patient";
1234             tableMapping.ColumnMappings.Add("Id", "Id");
1235             tableMapping.ColumnMappings.Add("name", "name");
1236             tableMapping.ColumnMappings.Add("gen", "gen");
1237             tableMapping.ColumnMappings.Add("age", "age");
1238             tableMapping.ColumnMappings.Add("date", "date");
1239             tableMapping.ColumnMappings.Add("cont", "cont");
1240             tableMapping.ColumnMappings.Add("addr", "addr");
1241             tableMapping.ColumnMappings.Add("disease", "disease");
1242             tableMapping.ColumnMappings.Add("status", "status");
1243             tableMapping.ColumnMappings.Add("r_type", "r_type");
1244             tableMapping.ColumnMappings.Add("building", "building");
1245             tableMapping.ColumnMappings.Add("r_no", "r_no");
1246             tableMapping.ColumnMappings.Add("price", "price");
1247             this._adapter.TableMappings.Add(tableMapping);
1248             this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
1249             this._adapter.DeleteCommand.Connection = this.Connection;
1250             this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[patient] WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gen = 1 AND [gen] IS NULL) OR ([gen] = @Original_gen)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_date = 1 AND [date] IS NULL) OR ([date] = @Original_date)) AND ((@IsNull_cont = 1 AND [cont] IS NULL) OR ([cont] = @Original_cont)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_disease = 1 AND [disease] IS NULL) OR ([disease] = @Original_disease)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_building = 1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)))";
1251             this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
1252             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Id", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Id", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1253             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_name", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "name", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1254             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_name", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "name", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1255             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_gen", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "gen", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1256             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_gen", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "gen", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1257             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_age", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "age", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1258             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_age", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "age", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1259             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1260             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1261             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_cont", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "cont", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1262             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_cont", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "cont", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1263             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_addr", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "addr", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1264             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_addr", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "addr", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1265             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_disease", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "disease", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1266             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_disease", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "disease", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1267             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_status", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "status", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1268             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_status", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "status", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1269             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_r_type", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_type", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1270             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_r_type", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_type", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1271             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_building", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "building", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1272             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_building", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "building", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1273             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_r_no", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_no", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1274             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_r_no", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_no", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1275             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_price", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "price", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1276             this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_price", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "price", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1277             this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
1278             this._adapter.InsertCommand.Connection = this.Connection;
1279             this._adapter.InsertCommand.CommandText = @"INSERT INTO [dbo].[patient] ([Id], [name], [gen], [age], [date], [cont], [addr], [disease], [status], [r_type], [building], [r_no], [price]) VALUES (@Id, @name, @gen, @age, @date, @cont, @addr, @disease, @status, @r_type, @building, @r_no, @price);
1280 SELECT Id, name, gen, age, date, cont, addr, disease, status, r_type, building, r_no, price FROM patient WHERE (Id = @Id)";
1281             this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
1282             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Id", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1283             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@name", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1284             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@gen", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "gen", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1285             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@age", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "age", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1286             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1287             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@cont", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "cont", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1288             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@addr", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "addr", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1289             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@disease", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "disease", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1290             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@status", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1291             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@r_type", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_type", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1292             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@building", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "building", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1293             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@r_no", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_no", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1294             this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@price", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "price", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1295             this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
1296             this._adapter.UpdateCommand.Connection = this.Connection;
1297             this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[patient] SET [Id] = @Id, [name] = @name, [gen] = @gen, [age] = @age, [date] = @date, [cont] = @cont, [addr] = @addr, [disease] = @disease, [status] = @status, [r_type] = @r_type, [building] = @building, [r_no] = @r_no, [price] = @price WHERE (([Id] = @Original_Id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_gen = 1 AND [gen] IS NULL) OR ([gen] = @Original_gen)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_date = 1 AND [date] IS NULL) OR ([date] = @Original_date)) AND ((@IsNull_cont = 1 AND [cont] IS NULL) OR ([cont] = @Original_cont)) AND ((@IsNull_addr = 1 AND [addr] IS NULL) OR ([addr] = @Original_addr)) AND ((@IsNull_disease = 1 AND [disease] IS NULL) OR ([disease] = @Original_disease)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ((@IsNull_r_type = 1 AND [r_type] IS NULL) OR ([r_type] = @Original_r_type)) AND ((@IsNull_building = 1 AND [building] IS NULL) OR ([building] = @Original_building)) AND ((@IsNull_r_no = 1 AND [r_no] IS NULL) OR ([r_no] = @Original_r_no)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)));
1298 SELECT Id, name, gen, age, date, cont, addr, disease, status, r_type, building, r_no, price FROM patient WHERE (Id = @Id)";
1299             this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
1300             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Id", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1301             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@name", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1302             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@gen", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "gen", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1303             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@age", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "age", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1304             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@date", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1305             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@cont", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "cont", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1306             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@addr", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "addr", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1307             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@disease", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "disease", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1308             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@status", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "status", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1309             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@r_type", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_type", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1310             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@building", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "building", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1311             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@r_no", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_no", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1312             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@price", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "price", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
1313             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_Id", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Id", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1314             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_name", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "name", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1315             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_name", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "name", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1316             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_gen", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "gen", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1317             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_gen", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "gen", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1318             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_age", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "age", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1319             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_age", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "age", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1320             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_date", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1321             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_date", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "date", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1322             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_cont", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "cont", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1323             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_cont", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "cont", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1324             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_addr", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "addr", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1325             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_addr", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "addr", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1326             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_disease", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "disease", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1327             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_disease", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "disease", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1328             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_status", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "status", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1329             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_status", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "status", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1330             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_r_type", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_type", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1331             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_r_type", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_type", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1332             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_building", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "building", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1333             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_building", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "building", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1334             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_r_no", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_no", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1335             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_r_no", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "r_no", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1336             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_price", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "price", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
1337             this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_price", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "price", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
1338         }
1339         
1340         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1341         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1342         private void InitConnection() {
1343             this._connection = new global::System.Data.SqlClient.SqlConnection();
1344             this._connection.ConnectionString = global::HospitalManagementSystemCSharp.Properties.Settings.Default.hospitalConnectionString;
1345         }
1346         
1347         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1348         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1349         private void InitCommandCollection() {
1350             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
1351             this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
1352             this._commandCollection[0].Connection = this.Connection;
1353             this._commandCollection[0].CommandText = "SELECT Id, name, gen, age, date, cont, addr, disease, status, r_type, building, r" +
1354                 "_no, price FROM dbo.patient";
1355             this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
1356         }
1357         
1358         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1359         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1360         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1361         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
1362         public virtual int Fill(hospitalDataSet1.patientDataTable dataTable) {
1363             this.Adapter.SelectCommand = this.CommandCollection[0];
1364             if ((this.ClearBeforeFill == true)) {
1365                 dataTable.Clear();
1366             }
1367             int returnValue = this.Adapter.Fill(dataTable);
1368             return returnValue;
1369         }
1370         
1371         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1372         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1373         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1374         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
1375         public virtual hospitalDataSet1.patientDataTable GetData() {
1376             this.Adapter.SelectCommand = this.CommandCollection[0];
1377             hospitalDataSet1.patientDataTable dataTable = new hospitalDataSet1.patientDataTable();
1378             this.Adapter.Fill(dataTable);
1379             return dataTable;
1380         }
1381         
1382         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1383         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1384         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1385         public virtual int Update(hospitalDataSet1.patientDataTable dataTable) {
1386             return this.Adapter.Update(dataTable);
1387         }
1388         
1389         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1390         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1391         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1392         public virtual int Update(hospitalDataSet1 dataSet) {
1393             return this.Adapter.Update(dataSet, "patient");
1394         }
1395         
1396         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1397         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1398         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1399         public virtual int Update(global::System.Data.DataRow dataRow) {
1400             return this.Adapter.Update(new global::System.Data.DataRow[] {
1401                         dataRow});
1402         }
1403         
1404         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1405         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1406         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1407         public virtual int Update(global::System.Data.DataRow[] dataRows) {
1408             return this.Adapter.Update(dataRows);
1409         }
1410         
1411         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1412         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1413         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1414         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
1415         public virtual int Delete(int Original_Id, string Original_name, string Original_gen, string Original_age, string Original_date, string Original_cont, string Original_addr, string Original_disease, string Original_status, string Original_r_type, string Original_building, string Original_r_no, string Original_price) {
1416             this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(Original_Id));
1417             if ((Original_name == null)) {
1418                 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
1419                 this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
1420             }
1421             else {
1422                 this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
1423                 this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_name));
1424             }
1425             if ((Original_gen == null)) {
1426                 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
1427                 this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
1428             }
1429             else {
1430                 this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
1431                 this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_gen));
1432             }
1433             if ((Original_age == null)) {
1434                 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
1435                 this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;
1436             }
1437             else {
1438                 this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
1439                 this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_age));
1440             }
1441             if ((Original_date == null)) {
1442                 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
1443                 this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
1444             }
1445             else {
1446                 this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
1447                 this.Adapter.DeleteCommand.Parameters[8].Value = ((string)(Original_date));
1448             }
1449             if ((Original_cont == null)) {
1450                 this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
1451                 this.Adapter.DeleteCommand.Parameters[10].Value = global::System.DBNull.Value;
1452             }
1453             else {
1454                 this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
1455                 this.Adapter.DeleteCommand.Parameters[10].Value = ((string)(Original_cont));
1456             }
1457             if ((Original_addr == null)) {
1458                 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1));
1459                 this.Adapter.DeleteCommand.Parameters[12].Value = global::System.DBNull.Value;
1460             }
1461             else {
1462                 this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
1463                 this.Adapter.DeleteCommand.Parameters[12].Value = ((string)(Original_addr));
1464             }
1465             if ((Original_disease == null)) {
1466                 this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(1));
1467                 this.Adapter.DeleteCommand.Parameters[14].Value = global::System.DBNull.Value;
1468             }
1469             else {
1470                 this.Adapter.DeleteCommand.Parameters[13].Value = ((object)(0));
1471                 this.Adapter.DeleteCommand.Parameters[14].Value = ((string)(Original_disease));
1472             }
1473             if ((Original_status == null)) {
1474                 this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(1));
1475                 this.Adapter.DeleteCommand.Parameters[16].Value = global::System.DBNull.Value;
1476             }
1477             else {
1478                 this.Adapter.DeleteCommand.Parameters[15].Value = ((object)(0));
1479                 this.Adapter.DeleteCommand.Parameters[16].Value = ((string)(Original_status));
1480             }
1481             if ((Original_r_type == null)) {
1482                 this.Adapter.DeleteCommand.Parameters[17].Value = ((object)(1));
1483                 this.Adapter.DeleteCommand.Parameters[18].Value = global::System.DBNull.Value;
1484             }
1485             else {
1486                 this.Adapter.DeleteCommand.Parameters[17].Value = ((object)(0));
1487                 this.Adapter.DeleteCommand.Parameters[18].Value = ((string)(Original_r_type));
1488             }
1489             if ((Original_building == null)) {
1490                 this.Adapter.DeleteCommand.Parameters[19].Value = ((object)(1));
1491                 this.Adapter.DeleteCommand.Parameters[20].Value = global::System.DBNull.Value;
1492             }
1493             else {
1494                 this.Adapter.DeleteCommand.Parameters[19].Value = ((object)(0));
1495                 this.Adapter.DeleteCommand.Parameters[20].Value = ((string)(Original_building));
1496             }
1497             if ((Original_r_no == null)) {
1498                 this.Adapter.DeleteCommand.Parameters[21].Value = ((object)(1));
1499                 this.Adapter.DeleteCommand.Parameters[22].Value = global::System.DBNull.Value;
1500             }
1501             else {
1502                 this.Adapter.DeleteCommand.Parameters[21].Value = ((object)(0));
1503                 this.Adapter.DeleteCommand.Parameters[22].Value = ((string)(Original_r_no));
1504             }
1505             if ((Original_price == null)) {
1506                 this.Adapter.DeleteCommand.Parameters[23].Value = ((object)(1));
1507                 this.Adapter.DeleteCommand.Parameters[24].Value = global::System.DBNull.Value;
1508             }
1509             else {
1510                 this.Adapter.DeleteCommand.Parameters[23].Value = ((object)(0));
1511                 this.Adapter.DeleteCommand.Parameters[24].Value = ((string)(Original_price));
1512             }
1513             global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
1514             if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
1515                         != global::System.Data.ConnectionState.Open)) {
1516                 this.Adapter.DeleteCommand.Connection.Open();
1517             }
1518             try {
1519                 int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
1520                 return returnValue;
1521             }
1522             finally {
1523                 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1524                     this.Adapter.DeleteCommand.Connection.Close();
1525                 }
1526             }
1527         }
1528         
1529         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1530         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1531         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1532         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
1533         public virtual int Insert(int Id, string name, string gen, string age, string date, string cont, string addr, string disease, string status, string r_type, string building, string r_no, string price) {
1534             this.Adapter.InsertCommand.Parameters[0].Value = ((int)(Id));
1535             if ((name == null)) {
1536                 this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
1537             }
1538             else {
1539                 this.Adapter.InsertCommand.Parameters[1].Value = ((string)(name));
1540             }
1541             if ((gen == null)) {
1542                 this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
1543             }
1544             else {
1545                 this.Adapter.InsertCommand.Parameters[2].Value = ((string)(gen));
1546             }
1547             if ((age == null)) {
1548                 this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
1549             }
1550             else {
1551                 this.Adapter.InsertCommand.Parameters[3].Value = ((string)(age));
1552             }
1553             if ((date == null)) {
1554                 this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
1555             }
1556             else {
1557                 this.Adapter.InsertCommand.Parameters[4].Value = ((string)(date));
1558             }
1559             if ((cont == null)) {
1560                 this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
1561             }
1562             else {
1563                 this.Adapter.InsertCommand.Parameters[5].Value = ((string)(cont));
1564             }
1565             if ((addr == null)) {
1566                 this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
1567             }
1568             else {
1569                 this.Adapter.InsertCommand.Parameters[6].Value = ((string)(addr));
1570             }
1571             if ((disease == null)) {
1572                 this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
1573             }
1574             else {
1575                 this.Adapter.InsertCommand.Parameters[7].Value = ((string)(disease));
1576             }
1577             if ((status == null)) {
1578                 this.Adapter.InsertCommand.Parameters[8].Value = global::System.DBNull.Value;
1579             }
1580             else {
1581                 this.Adapter.InsertCommand.Parameters[8].Value = ((string)(status));
1582             }
1583             if ((r_type == null)) {
1584                 this.Adapter.InsertCommand.Parameters[9].Value = global::System.DBNull.Value;
1585             }
1586             else {
1587                 this.Adapter.InsertCommand.Parameters[9].Value = ((string)(r_type));
1588             }
1589             if ((building == null)) {
1590                 this.Adapter.InsertCommand.Parameters[10].Value = global::System.DBNull.Value;
1591             }
1592             else {
1593                 this.Adapter.InsertCommand.Parameters[10].Value = ((string)(building));
1594             }
1595             if ((r_no == null)) {
1596                 this.Adapter.InsertCommand.Parameters[11].Value = global::System.DBNull.Value;
1597             }
1598             else {
1599                 this.Adapter.InsertCommand.Parameters[11].Value = ((string)(r_no));
1600             }
1601             if ((price == null)) {
1602                 this.Adapter.InsertCommand.Parameters[12].Value = global::System.DBNull.Value;
1603             }
1604             else {
1605                 this.Adapter.InsertCommand.Parameters[12].Value = ((string)(price));
1606             }
1607             global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
1608             if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
1609                         != global::System.Data.ConnectionState.Open)) {
1610                 this.Adapter.InsertCommand.Connection.Open();
1611             }
1612             try {
1613                 int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
1614                 return returnValue;
1615             }
1616             finally {
1617                 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1618                     this.Adapter.InsertCommand.Connection.Close();
1619                 }
1620             }
1621         }
1622         
1623         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1624         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1625         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1626         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
1627         public virtual int Update(
1628                     int Id,
1629                     string name,
1630                     string gen,
1631                     string age,
1632                     string date,
1633                     string cont,
1634                     string addr,
1635                     string disease,
1636                     string status,
1637                     string r_type,
1638                     string building,
1639                     string r_no,
1640                     string price,
1641                     int Original_Id,
1642                     string Original_name,
1643                     string Original_gen,
1644                     string Original_age,
1645                     string Original_date,
1646                     string Original_cont,
1647                     string Original_addr,
1648                     string Original_disease,
1649                     string Original_status,
1650                     string Original_r_type,
1651                     string Original_building,
1652                     string Original_r_no,
1653                     string Original_price) {
1654             this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(Id));
1655             if ((name == null)) {
1656                 this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
1657             }
1658             else {
1659                 this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(name));
1660             }
1661             if ((gen == null)) {
1662                 this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
1663             }
1664             else {
1665                 this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(gen));
1666             }
1667             if ((age == null)) {
1668                 this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
1669             }
1670             else {
1671                 this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(age));
1672             }
1673             if ((date == null)) {
1674                 this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
1675             }
1676             else {
1677                 this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(date));
1678             }
1679             if ((cont == null)) {
1680                 this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
1681             }
1682             else {
1683                 this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(cont));
1684             }
1685             if ((addr == null)) {
1686                 this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
1687             }
1688             else {
1689                 this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(addr));
1690             }
1691             if ((disease == null)) {
1692                 this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value;
1693             }
1694             else {
1695                 this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(disease));
1696             }
1697             if ((status == null)) {
1698                 this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
1699             }
1700             else {
1701                 this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(status));
1702             }
1703             if ((r_type == null)) {
1704                 this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value;
1705             }
1706             else {
1707                 this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(r_type));
1708             }
1709             if ((building == null)) {
1710                 this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value;
1711             }
1712             else {
1713                 this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(building));
1714             }
1715             if ((r_no == null)) {
1716                 this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value;
1717             }
1718             else {
1719                 this.Adapter.UpdateCommand.Parameters[11].Value = ((string)(r_no));
1720             }
1721             if ((price == null)) {
1722                 this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value;
1723             }
1724             else {
1725                 this.Adapter.UpdateCommand.Parameters[12].Value = ((string)(price));
1726             }
1727             this.Adapter.UpdateCommand.Parameters[13].Value = ((int)(Original_Id));
1728             if ((Original_name == null)) {
1729                 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(1));
1730                 this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value;
1731             }
1732             else {
1733                 this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(0));
1734                 this.Adapter.UpdateCommand.Parameters[15].Value = ((string)(Original_name));
1735             }
1736             if ((Original_gen == null)) {
1737                 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(1));
1738                 this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value;
1739             }
1740             else {
1741                 this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(0));
1742                 this.Adapter.UpdateCommand.Parameters[17].Value = ((string)(Original_gen));
1743             }
1744             if ((Original_age == null)) {
1745                 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(1));
1746                 this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value;
1747             }
1748             else {
1749                 this.Adapter.UpdateCommand.Parameters[18].Value = ((object)(0));
1750                 this.Adapter.UpdateCommand.Parameters[19].Value = ((string)(Original_age));
1751             }
1752             if ((Original_date == null)) {
1753                 this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(1));
1754                 this.Adapter.UpdateCommand.Parameters[21].Value = global::System.DBNull.Value;
1755             }
1756             else {
1757                 this.Adapter.UpdateCommand.Parameters[20].Value = ((object)(0));
1758                 this.Adapter.UpdateCommand.Parameters[21].Value = ((string)(Original_date));
1759             }
1760             if ((Original_cont == null)) {
1761                 this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(1));
1762                 this.Adapter.UpdateCommand.Parameters[23].Value = global::System.DBNull.Value;
1763             }
1764             else {
1765                 this.Adapter.UpdateCommand.Parameters[22].Value = ((object)(0));
1766                 this.Adapter.UpdateCommand.Parameters[23].Value = ((string)(Original_cont));
1767             }
1768             if ((Original_addr == null)) {
1769                 this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(1));
1770                 this.Adapter.UpdateCommand.Parameters[25].Value = global::System.DBNull.Value;
1771             }
1772             else {
1773                 this.Adapter.UpdateCommand.Parameters[24].Value = ((object)(0));
1774                 this.Adapter.UpdateCommand.Parameters[25].Value = ((string)(Original_addr));
1775             }
1776             if ((Original_disease == null)) {
1777                 this.Adapter.UpdateCommand.Parameters[26].Value = ((object)(1));
1778                 this.Adapter.UpdateCommand.Parameters[27].Value = global::System.DBNull.Value;
1779             }
1780             else {
1781                 this.Adapter.UpdateCommand.Parameters[26].Value = ((object)(0));
1782                 this.Adapter.UpdateCommand.Parameters[27].Value = ((string)(Original_disease));
1783             }
1784             if ((Original_status == null)) {
1785                 this.Adapter.UpdateCommand.Parameters[28].Value = ((object)(1));
1786                 this.Adapter.UpdateCommand.Parameters[29].Value = global::System.DBNull.Value;
1787             }
1788             else {
1789                 this.Adapter.UpdateCommand.Parameters[28].Value = ((object)(0));
1790                 this.Adapter.UpdateCommand.Parameters[29].Value = ((string)(Original_status));
1791             }
1792             if ((Original_r_type == null)) {
1793                 this.Adapter.UpdateCommand.Parameters[30].Value = ((object)(1));
1794                 this.Adapter.UpdateCommand.Parameters[31].Value = global::System.DBNull.Value;
1795             }
1796             else {
1797                 this.Adapter.UpdateCommand.Parameters[30].Value = ((object)(0));
1798                 this.Adapter.UpdateCommand.Parameters[31].Value = ((string)(Original_r_type));
1799             }
1800             if ((Original_building == null)) {
1801                 this.Adapter.UpdateCommand.Parameters[32].Value = ((object)(1));
1802                 this.Adapter.UpdateCommand.Parameters[33].Value = global::System.DBNull.Value;
1803             }
1804             else {
1805                 this.Adapter.UpdateCommand.Parameters[32].Value = ((object)(0));
1806                 this.Adapter.UpdateCommand.Parameters[33].Value = ((string)(Original_building));
1807             }
1808             if ((Original_r_no == null)) {
1809                 this.Adapter.UpdateCommand.Parameters[34].Value = ((object)(1));
1810                 this.Adapter.UpdateCommand.Parameters[35].Value = global::System.DBNull.Value;
1811             }
1812             else {
1813                 this.Adapter.UpdateCommand.Parameters[34].Value = ((object)(0));
1814                 this.Adapter.UpdateCommand.Parameters[35].Value = ((string)(Original_r_no));
1815             }
1816             if ((Original_price == null)) {
1817                 this.Adapter.UpdateCommand.Parameters[36].Value = ((object)(1));
1818                 this.Adapter.UpdateCommand.Parameters[37].Value = global::System.DBNull.Value;
1819             }
1820             else {
1821                 this.Adapter.UpdateCommand.Parameters[36].Value = ((object)(0));
1822                 this.Adapter.UpdateCommand.Parameters[37].Value = ((string)(Original_price));
1823             }
1824             global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
1825             if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
1826                         != global::System.Data.ConnectionState.Open)) {
1827                 this.Adapter.UpdateCommand.Connection.Open();
1828             }
1829             try {
1830                 int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
1831                 return returnValue;
1832             }
1833             finally {
1834                 if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
1835                     this.Adapter.UpdateCommand.Connection.Close();
1836                 }
1837             }
1838         }
1839         
1840         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1841         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1842         [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
1843         [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
1844         public virtual int Update(
1845                     string name,
1846                     string gen,
1847                     string age,
1848                     string date,
1849                     string cont,
1850                     string addr,
1851                     string disease,
1852                     string status,
1853                     string r_type,
1854                     string building,
1855                     string r_no,
1856                     string price,
1857                     int Original_Id,
1858                     string Original_name,
1859                     string Original_gen,
1860                     string Original_age,
1861                     string Original_date,
1862                     string Original_cont,
1863                     string Original_addr,
1864                     string Original_disease,
1865                     string Original_status,
1866                     string Original_r_type,
1867                     string Original_building,
1868                     string Original_r_no,
1869                     string Original_price) {
1870             return this.Update(Original_Id, name, gen, age, date, cont, addr, disease, status, r_type, building, r_no, price, Original_Id, Original_name, Original_gen, Original_age, Original_date, Original_cont, Original_addr, Original_disease, Original_status, Original_r_type, Original_building, Original_r_no, Original_price);
1871         }
1872     }
1873     
1874     /// <summary>
1875     ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
1876     ///</summary>
1877     [global::System.ComponentModel.DesignerCategoryAttribute("code")]
1878     [global::System.ComponentModel.ToolboxItem(true)]
1879     [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
1880         "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
1881     [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
1882     public partial class TableAdapterManager : global::System.ComponentModel.Component {
1883         
1884         private UpdateOrderOption _updateOrder;
1885         
1886         private patientTableAdapter _patientTableAdapter;
1887         
1888         private bool _backupDataSetBeforeUpdate;
1889         
1890         private global::System.Data.IDbConnection _connection;
1891         
1892         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1893         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1894         public UpdateOrderOption UpdateOrder {
1895             get {
1896                 return this._updateOrder;
1897             }
1898             set {
1899                 this._updateOrder = value;
1900             }
1901         }
1902         
1903         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1904         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1905         [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
1906             "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
1907             "a", "System.Drawing.Design.UITypeEditor")]
1908         public patientTableAdapter patientTableAdapter {
1909             get {
1910                 return this._patientTableAdapter;
1911             }
1912             set {
1913                 this._patientTableAdapter = value;
1914             }
1915         }
1916         
1917         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1918         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1919         public bool BackupDataSetBeforeUpdate {
1920             get {
1921                 return this._backupDataSetBeforeUpdate;
1922             }
1923             set {
1924                 this._backupDataSetBeforeUpdate = value;
1925             }
1926         }
1927         
1928         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1929         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1930         [global::System.ComponentModel.Browsable(false)]
1931         public global::System.Data.IDbConnection Connection {
1932             get {
1933                 if ((this._connection != null)) {
1934                     return this._connection;
1935                 }
1936                 if (((this._patientTableAdapter != null)
1937                             && (this._patientTableAdapter.Connection != null))) {
1938                     return this._patientTableAdapter.Connection;
1939                 }
1940                 return null;
1941             }
1942             set {
1943                 this._connection = value;
1944             }
1945         }
1946         
1947         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1948         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1949         [global::System.ComponentModel.Browsable(false)]
1950         public int TableAdapterInstanceCount {
1951             get {
1952                 int count = 0;
1953                 if ((this._patientTableAdapter != null)) {
1954                     count = (count + 1);
1955                 }
1956                 return count;
1957             }
1958         }
1959         
1960         /// <summary>
1961         ///Update rows in top-down order.
1962         ///</summary>
1963         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1964         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1965         private int UpdateUpdatedRows(hospitalDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1966             int result = 0;
1967             if ((this._patientTableAdapter != null)) {
1968                 global::System.Data.DataRow[] updatedRows = dataSet.patient.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
1969                 updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
1970                 if (((updatedRows != null)
1971                             && (0 < updatedRows.Length))) {
1972                     result = (result + this._patientTableAdapter.Update(updatedRows));
1973                     allChangedRows.AddRange(updatedRows);
1974                 }
1975             }
1976             return result;
1977         }
1978         
1979         /// <summary>
1980         ///Insert rows in top-down order.
1981         ///</summary>
1982         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
1983         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
1984         private int UpdateInsertedRows(hospitalDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
1985             int result = 0;
1986             if ((this._patientTableAdapter != null)) {
1987                 global::System.Data.DataRow[] addedRows = dataSet.patient.Select(null, null, global::System.Data.DataViewRowState.Added);
1988                 if (((addedRows != null)
1989                             && (0 < addedRows.Length))) {
1990                     result = (result + this._patientTableAdapter.Update(addedRows));
1991                     allAddedRows.AddRange(addedRows);
1992                 }
1993             }
1994             return result;
1995         }
1996         
1997         /// <summary>
1998         ///Delete rows in bottom-up order.
1999         ///</summary>
2000         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2001         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2002         private int UpdateDeletedRows(hospitalDataSet1 dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
2003             int result = 0;
2004             if ((this._patientTableAdapter != null)) {
2005                 global::System.Data.DataRow[] deletedRows = dataSet.patient.Select(null, null, global::System.Data.DataViewRowState.Deleted);
2006                 if (((deletedRows != null)
2007                             && (0 < deletedRows.Length))) {
2008                     result = (result + this._patientTableAdapter.Update(deletedRows));
2009                     allChangedRows.AddRange(deletedRows);
2010                 }
2011             }
2012             return result;
2013         }
2014         
2015         /// <summary>
2016         ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
2017         ///</summary>
2018         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2019         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2020         private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
2021             if (((updatedRows == null)
2022                         || (updatedRows.Length < 1))) {
2023                 return updatedRows;
2024             }
2025             if (((allAddedRows == null)
2026                         || (allAddedRows.Count < 1))) {
2027                 return updatedRows;
2028             }
2029             global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
2030             for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
2031                 global::System.Data.DataRow row = updatedRows[i];
2032                 if ((allAddedRows.Contains(row) == false)) {
2033                     realUpdatedRows.Add(row);
2034                 }
2035             }
2036             return realUpdatedRows.ToArray();
2037         }
2038         
2039         /// <summary>
2040         ///Update all changes to the dataset.
2041         ///</summary>
2042         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2043         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2044         public virtual int UpdateAll(hospitalDataSet1 dataSet) {
2045             if ((dataSet == null)) {
2046                 throw new global::System.ArgumentNullException("dataSet");
2047             }
2048             if ((dataSet.HasChanges() == false)) {
2049                 return 0;
2050             }
2051             if (((this._patientTableAdapter != null)
2052                         && (this.MatchTableAdapterConnection(this._patientTableAdapter.Connection) == false))) {
2053                 throw new global::System.ArgumentException("All TableAdapters managed by a TableAdapterManager must use the same connection s" +
2054                         "tring.");
2055             }
2056             global::System.Data.IDbConnection workConnection = this.Connection;
2057             if ((workConnection == null)) {
2058                 throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" +
2059                         "ger TableAdapter property to a valid TableAdapter instance.");
2060             }
2061             bool workConnOpened = false;
2062             if (((workConnection.State & global::System.Data.ConnectionState.Broken)
2063                         == global::System.Data.ConnectionState.Broken)) {
2064                 workConnection.Close();
2065             }
2066             if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
2067                 workConnection.Open();
2068                 workConnOpened = true;
2069             }
2070             global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
2071             if ((workTransaction == null)) {
2072                 throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" +
2073                         "ctions or the current state is not allowing the transaction to begin.");
2074             }
2075             global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
2076             global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
2077             global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
2078             global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
2079             int result = 0;
2080             global::System.Data.DataSet backupDataSet = null;
2081             if (this.BackupDataSetBeforeUpdate) {
2082                 backupDataSet = new global::System.Data.DataSet();
2083                 backupDataSet.Merge(dataSet);
2084             }
2085             try {
2086                 // ---- Prepare for update -----------
2087                 //
2088                 if ((this._patientTableAdapter != null)) {
2089                     revertConnections.Add(this._patientTableAdapter, this._patientTableAdapter.Connection);
2090                     this._patientTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(workConnection));
2091                     this._patientTableAdapter.Transaction = ((global::System.Data.SqlClient.SqlTransaction)(workTransaction));
2092                     if (this._patientTableAdapter.Adapter.AcceptChangesDuringUpdate) {
2093                         this._patientTableAdapter.Adapter.AcceptChangesDuringUpdate = false;
2094                         adaptersWithAcceptChangesDuringUpdate.Add(this._patientTableAdapter.Adapter);
2095                     }
2096                 }
2097                 //
2098                 //---- Perform updates -----------
2099                 //
2100                 if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
2101                     result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
2102                     result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
2103                 }
2104                 else {
2105                     result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
2106                     result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
2107                 }
2108                 result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
2109                 //
2110                 //---- Commit updates -----------
2111                 //
2112                 workTransaction.Commit();
2113                 if ((0 < allAddedRows.Count)) {
2114                     global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
2115                     allAddedRows.CopyTo(rows);
2116                     for (int i = 0; (i < rows.Length); i = (i + 1)) {
2117                         global::System.Data.DataRow row = rows[i];
2118                         row.AcceptChanges();
2119                     }
2120                 }
2121                 if ((0 < allChangedRows.Count)) {
2122                     global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
2123                     allChangedRows.CopyTo(rows);
2124                     for (int i = 0; (i < rows.Length); i = (i + 1)) {
2125                         global::System.Data.DataRow row = rows[i];
2126                         row.AcceptChanges();
2127                     }
2128                 }
2129             }
2130             catch (global::System.Exception ex) {
2131                 workTransaction.Rollback();
2132                 // ---- Restore the dataset -----------
2133                 if (this.BackupDataSetBeforeUpdate) {
2134                     global::System.Diagnostics.Debug.Assert((backupDataSet != null));
2135                     dataSet.Clear();
2136                     dataSet.Merge(backupDataSet);
2137                 }
2138                 else {
2139                     if ((0 < allAddedRows.Count)) {
2140                         global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
2141                         allAddedRows.CopyTo(rows);
2142                         for (int i = 0; (i < rows.Length); i = (i + 1)) {
2143                             global::System.Data.DataRow row = rows[i];
2144                             row.AcceptChanges();
2145                             row.SetAdded();
2146                         }
2147                     }
2148                 }
2149                 throw ex;
2150             }
2151             finally {
2152                 if (workConnOpened) {
2153                     workConnection.Close();
2154                 }
2155                 if ((this._patientTableAdapter != null)) {
2156                     this._patientTableAdapter.Connection = ((global::System.Data.SqlClient.SqlConnection)(revertConnections[this._patientTableAdapter]));
2157                     this._patientTableAdapter.Transaction = null;
2158                 }
2159                 if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
2160                     global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
2161                     adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
2162                     for (int i = 0; (i < adapters.Length); i = (i + 1)) {
2163                         global::System.Data.Common.DataAdapter adapter = adapters[i];
2164                         adapter.AcceptChangesDuringUpdate = true;
2165                     }
2166                 }
2167             }
2168             return result;
2169         }
2170         
2171         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2172         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2173         protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
2174             global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
2175         }
2176         
2177         [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2178         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2179         protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
2180             if ((this._connection != null)) {
2181                 return true;
2182             }
2183             if (((this.Connection == null)
2184                         || (inputConnection == null))) {
2185                 return true;
2186             }
2187             if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
2188                 return true;
2189             }
2190             return false;
2191         }
2192         
2193         /// <summary>
2194         ///Update Order Option
2195         ///</summary>
2196         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2197         public enum UpdateOrderOption {
2198             
2199             InsertUpdateDelete = 0,
2200             
2201             UpdateInsertDelete = 1,
2202         }
2203         
2204         /// <summary>
2205         ///Used to sort self-referenced table's rows
2206         ///</summary>
2207         [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2208         private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
2209             
2210             private global::System.Data.DataRelation _relation;
2211             
2212             private int _childFirst;
2213             
2214             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2215             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2216             internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
2217                 this._relation = relation;
2218                 if (childFirst) {
2219                     this._childFirst = -1;
2220                 }
2221                 else {
2222                     this._childFirst = 1;
2223                 }
2224             }
2225             
2226             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2227             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2228             private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
2229                 global::System.Diagnostics.Debug.Assert((row != null));
2230                 global::System.Data.DataRow root = row;
2231                 distance = 0;
2232
2233                 global::System.Collections.Generic.IDictionary<global::System.Data.DataRow, global::System.Data.DataRow> traversedRows = new global::System.Collections.Generic.Dictionary<global::System.Data.DataRow, global::System.Data.DataRow>();
2234                 traversedRows[row] = row;
2235
2236                 global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
2237                 for (
2238                 ; ((parent != null)
2239                             && (traversedRows.ContainsKey(parent) == false));
2240                 ) {
2241                     distance = (distance + 1);
2242                     root = parent;
2243                     traversedRows[parent] = parent;
2244                     parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
2245                 }
2246
2247                 if ((distance == 0)) {
2248                     traversedRows.Clear();
2249                     traversedRows[row] = row;
2250                     parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
2251                     for (
2252                     ; ((parent != null)
2253                                 && (traversedRows.ContainsKey(parent) == false));
2254                     ) {
2255                         distance = (distance + 1);
2256                         root = parent;
2257                         traversedRows[parent] = parent;
2258                         parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
2259                     }
2260                 }
2261
2262                 return root;
2263             }
2264             
2265             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
2266             [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
2267             public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
2268                 if (object.ReferenceEquals(row1, row2)) {
2269                     return 0;
2270                 }
2271                 if ((row1 == null)) {
2272                     return -1;
2273                 }
2274                 if ((row2 == null)) {
2275                     return 1;
2276                 }
2277
2278                 int distance1 = 0;
2279                 global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);
2280
2281                 int distance2 = 0;
2282                 global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);
2283
2284                 if (object.ReferenceEquals(root1, root2)) {
2285                     return (this._childFirst * distance1.CompareTo(distance2));
2286                 }
2287                 else {
2288                     global::System.Diagnostics.Debug.Assert(((root1.Table != null)
2289                                     && (root2.Table != null)));
2290                     if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
2291                         return -1;
2292                     }
2293                     else {
2294                         return 1;
2295                     }
2296                 }
2297             }
2298         }
2299     }
2300 }
2301
2302 #pragma warning restore 1591